[ROOT] dt FactResellerSale < WHERE DimResellerId EQ '99' >
57 items
| FactResellerSaleId | CarrierTrackingNumber | CustomerPONumber | DimCurrencyId | DimEmployeeId | DimProductId | DimPromotionId | DimResellerId | DimSalesTerritoryId | DiscountAmount | DueDate | ExtendedAmount | Freight | OrderDate | OrderQuantity | ProductStandardCost | RevisionNumber | SalesAmount | SalesOrderLineNumber | SalesOrderNumber | ShipDate | TaxAmt | TotalProductCost | UnitPrice | UnitPriceDiscountPct |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SO43862_1 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 344 | 99 | 5 | 2021-05-17 | 8159.98 | 204.00 | 2021-05-05 | 4 | 1912.15 | 1 | 8159.98 | 1 | SO43862 | 2021-05-12 | 652.80 | 7648.62 | 2039.99 | |||
| SO43862_2 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 292 | 99 | 5 | 2021-05-17 | 818.70 | 20.47 | 2021-05-05 | 1 | 706.81 | 1 | 818.70 | 2 | SO43862 | 2021-05-12 | 65.50 | 706.81 | 818.70 | |||
| SO43862_3 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 350 | 99 | 5 | 2021-05-17 | 6074.98 | 151.87 | 2021-05-05 | 3 | 1898.09 | 1 | 6074.98 | 3 | SO43862 | 2021-05-12 | 486.00 | 5694.28 | 2024.99 | |||
| SO43862_4 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 346 | 99 | 5 | 2021-05-17 | 8159.98 | 204.00 | 2021-05-05 | 4 | 1912.15 | 1 | 8159.98 | 4 | SO43862 | 2021-05-12 | 652.80 | 7648.62 | 2039.99 | |||
| SO43862_5 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 304 | 99 | 5 | 2021-05-17 | 1429.41 | 35.74 | 2021-05-05 | 2 | 617.03 | 1 | 1429.41 | 5 | SO43862 | 2021-05-12 | 114.35 | 1234.06 | 714.70 | |||
| SO43862_6 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 307 | 99 | 5 | 2021-05-17 | 1445.19 | 36.13 | 2021-05-05 | 2 | 623.84 | 1 | 1445.19 | 6 | SO43862 | 2021-05-12 | 115.62 | 1247.68 | 722.59 | |||
| SO43862_7 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 347 | 99 | 5 | 2021-05-17 | 4079.99 | 102.00 | 2021-05-05 | 2 | 1912.15 | 1 | 4079.99 | 7 | SO43862 | 2021-05-12 | 326.40 | 3824.31 | 2039.99 | |||
| SO43862_8 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 300 | 99 | 5 | 2021-05-17 | 809.76 | 20.24 | 2021-05-05 | 1 | 699.09 | 1 | 809.76 | 8 | SO43862 | 2021-05-12 | 64.78 | 699.09 | 809.76 | |||
| SO43862_9 | 68A2-4B5C-A7 | PO16211194171 | 100 | 285 | 218 | 99 | 5 | 2021-05-17 | 22.80 | 0.57 | 2021-05-05 | 4 | 3.40 | 1 | 22.80 | 9 | SO43862 | 2021-05-12 | 1.82 | 13.59 | 5.70 | |||
| SO44507_1 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 349 | 99 | 5 | 2021-08-17 | 6074.98 | 151.87 | 2021-08-05 | 3 | 1898.09 | 1 | 6074.98 | 1 | SO44507 | 2021-08-12 | 486.00 | 5694.28 | 2024.99 | |||
| SO44507_2 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 307 | 99 | 5 | 2021-08-17 | 2167.78 | 54.19 | 2021-08-05 | 3 | 623.84 | 1 | 2167.78 | 2 | SO44507 | 2021-08-12 | 173.42 | 1871.52 | 722.59 | |||
| SO44507_3 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 293 | 99 | 5 | 2021-08-17 | 722.59 | 18.06 | 2021-08-05 | 1 | 623.84 | 1 | 722.59 | 3 | SO44507 | 2021-08-12 | 57.81 | 623.84 | 722.59 | |||
| SO44507_4 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 292 | 99 | 5 | 2021-08-17 | 818.70 | 20.47 | 2021-08-05 | 1 | 706.81 | 1 | 818.70 | 4 | SO44507 | 2021-08-12 | 65.50 | 706.81 | 818.70 | |||
| SO44507_5 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 348 | 99 | 5 | 2021-08-17 | 6074.98 | 151.87 | 2021-08-05 | 3 | 1898.09 | 1 | 6074.98 | 5 | SO44507 | 2021-08-12 | 486.00 | 5694.28 | 2024.99 | |||
| SO44507_6 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 296 | 99 | 5 | 2021-08-17 | 714.70 | 17.87 | 2021-08-05 | 1 | 617.03 | 1 | 714.70 | 6 | SO44507 | 2021-08-12 | 57.18 | 617.03 | 714.70 | |||
| SO44507_7 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 347 | 99 | 5 | 2021-08-17 | 6119.98 | 153.00 | 2021-08-05 | 3 | 1912.15 | 1 | 6119.98 | 7 | SO44507 | 2021-08-12 | 489.60 | 5736.46 | 2039.99 | |||
| SO44507_8 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 300 | 99 | 5 | 2021-08-17 | 809.76 | 20.24 | 2021-08-05 | 1 | 699.09 | 1 | 809.76 | 8 | SO44507 | 2021-08-12 | 64.78 | 699.09 | 809.76 | |||
| SO44507_9 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 304 | 99 | 5 | 2021-08-17 | 714.70 | 17.87 | 2021-08-05 | 1 | 617.03 | 1 | 714.70 | 9 | SO44507 | 2021-08-12 | 57.18 | 617.03 | 714.70 | |||
| SO44507_10 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 350 | 99 | 5 | 2021-08-17 | 10124.97 | 253.12 | 2021-08-05 | 5 | 1898.09 | 1 | 10124.97 | 10 | SO44507 | 2021-08-12 | 810.00 | 9490.47 | 2024.99 | |||
| SO44507_11 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 346 | 99 | 5 | 2021-08-17 | 4079.99 | 102.00 | 2021-08-05 | 2 | 1912.15 | 1 | 4079.99 | 11 | SO44507 | 2021-08-12 | 326.40 | 3824.31 | 2039.99 | |||
| SO44507_12 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 218 | 99 | 5 | 2021-08-17 | 11.40 | 0.29 | 2021-08-05 | 2 | 3.40 | 1 | 11.40 | 12 | SO44507 | 2021-08-12 | 0.91 | 6.79 | 5.70 | |||
| SO44507_13 | 0B2D-4AB3-BE | PO16211193285 | 100 | 285 | 299 | 99 | 5 | 2021-08-17 | 809.76 | 20.24 | 2021-08-05 | 1 | 699.09 | 1 | 809.76 | 13 | SO44507 | 2021-08-12 | 64.78 | 699.09 | 809.76 | |||
| SO45289_1 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 344 | 99 | 5 | 2021-11-17 | 12239.96 | 306.00 | 2021-11-05 | 6 | 1912.15 | 1 | 12239.96 | 1 | SO45289 | 2021-11-12 | 979.20 | 11472.93 | 2039.99 | |||
| SO45289_2 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 351 | 99 | 5 | 2021-11-17 | 4049.99 | 101.25 | 2021-11-05 | 2 | 1898.09 | 1 | 4049.99 | 2 | SO45289 | 2021-11-12 | 324.00 | 3796.19 | 2024.99 | |||
| SO45289_3 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 300 | 99 | 5 | 2021-11-17 | 1619.52 | 40.49 | 2021-11-05 | 2 | 699.09 | 1 | 1619.52 | 3 | SO45289 | 2021-11-12 | 129.56 | 1398.19 | 809.76 | |||
| SO45289_4 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 218 | 99 | 5 | 2021-11-17 | 11.40 | 0.29 | 2021-11-05 | 2 | 3.40 | 1 | 11.40 | 4 | SO45289 | 2021-11-12 | 0.91 | 6.79 | 5.70 | |||
| SO45289_5 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 347 | 99 | 5 | 2021-11-17 | 2039.99 | 51.00 | 2021-11-05 | 1 | 1912.15 | 1 | 2039.99 | 5 | SO45289 | 2021-11-12 | 163.20 | 1912.15 | 2039.99 | |||
| SO45289_6 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 348 | 99 | 5 | 2021-11-17 | 8099.98 | 202.50 | 2021-11-05 | 4 | 1898.09 | 1 | 8099.98 | 6 | SO45289 | 2021-11-12 | 648.00 | 7592.38 | 2024.99 | |||
| SO45289_7 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 350 | 99 | 5 | 2021-11-17 | 8099.98 | 202.50 | 2021-11-05 | 4 | 1898.09 | 1 | 8099.98 | 7 | SO45289 | 2021-11-12 | 648.00 | 7592.38 | 2024.99 | |||
| SO45289_8 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 293 | 99 | 5 | 2021-11-17 | 1445.19 | 36.13 | 2021-11-05 | 2 | 623.84 | 1 | 1445.19 | 8 | SO45289 | 2021-11-12 | 115.62 | 1247.68 | 722.59 | |||
| SO45289_9 | 741A-40B6-8E | PO16211190433 | 100 | 285 | 304 | 99 | 5 | 2021-11-17 | 2144.11 | 53.60 | 2021-11-05 | 3 | 617.03 | 1 | 2144.11 | 9 | SO45289 | 2021-11-12 | 171.53 | 1851.08 | 714.70 | |||
| SO46047_1 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 347 | 99 | 5 | 2022-02-14 | 8159.98 | 204.00 | 2022-02-02 | 4 | 1912.15 | 1 | 8159.98 | 1 | SO46047 | 2022-02-09 | 652.80 | 7648.62 | 2039.99 | |||
| SO46047_2 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 349 | 99 | 5 | 2022-02-14 | 10124.97 | 253.12 | 2022-02-02 | 5 | 1898.09 | 1 | 10124.97 | 2 | SO46047 | 2022-02-09 | 810.00 | 9490.47 | 2024.99 | |||
| SO46047_3 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 307 | 99 | 5 | 2022-02-14 | 722.59 | 18.06 | 2022-02-02 | 1 | 623.84 | 1 | 722.59 | 3 | SO46047 | 2022-02-09 | 57.81 | 623.84 | 722.59 | |||
| SO46047_4 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 292 | 99 | 5 | 2022-02-14 | 818.70 | 20.47 | 2022-02-02 | 1 | 706.81 | 1 | 818.70 | 4 | SO46047 | 2022-02-09 | 65.50 | 706.81 | 818.70 | |||
| SO46047_5 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 350 | 99 | 5 | 2022-02-14 | 4049.99 | 101.25 | 2022-02-02 | 2 | 1898.09 | 1 | 4049.99 | 5 | SO46047 | 2022-02-09 | 324.00 | 3796.19 | 2024.99 | |||
| SO46047_6 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 288 | 99 | 5 | 2022-02-14 | 1445.19 | 36.13 | 2022-02-02 | 2 | 623.84 | 1 | 1445.19 | 6 | SO46047 | 2022-02-09 | 115.62 | 1247.68 | 722.59 | |||
| SO46047_7 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 218 | 99 | 5 | 2022-02-14 | 5.70 | 0.14 | 2022-02-02 | 1 | 3.40 | 1 | 5.70 | 7 | SO46047 | 2022-02-09 | 0.46 | 3.40 | 5.70 | |||
| SO46047_8 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 345 | 99 | 5 | 2022-02-14 | 8159.98 | 204.00 | 2022-02-02 | 4 | 1912.15 | 1 | 8159.98 | 8 | SO46047 | 2022-02-09 | 652.80 | 7648.62 | 2039.99 | |||
| SO46047_9 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 346 | 99 | 5 | 2022-02-14 | 6119.98 | 153.00 | 2022-02-02 | 3 | 1912.15 | 1 | 6119.98 | 9 | SO46047 | 2022-02-09 | 489.60 | 5736.46 | 2039.99 | |||
| SO46047_10 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 296 | 99 | 5 | 2022-02-14 | 714.70 | 17.87 | 2022-02-02 | 1 | 617.03 | 1 | 714.70 | 10 | SO46047 | 2022-02-09 | 57.18 | 617.03 | 714.70 | |||
| SO46047_11 | 2520-47B8-B9 | PO16211157418 | 100 | 285 | 351 | 99 | 5 | 2022-02-14 | 6074.98 | 151.87 | 2022-02-02 | 3 | 1898.09 | 1 | 6074.98 | 11 | SO46047 | 2022-02-09 | 486.00 | 5694.28 | 2024.99 | |||
| SO46962_1 | DB18-4737-90 | PO16211133020 | 100 | 285 | 352 | 99 | 5 | 2022-05-17 | 2485.70 | 62.14 | 2022-05-05 | 2 | 1117.86 | 1 | 2485.70 | 1 | SO46962 | 2022-05-12 | 198.86 | 2235.71 | 1242.85 | |||
| SO49110_1 | DB44-4376-BD | PO16211161509 | 100 | 285 | 420 | 99 | 5 | 2022-11-17 | 141.62 | 3.54 | 2022-11-05 | 1 | 104.80 | 1 | 141.62 | 1 | SO49110 | 2022-11-12 | 11.33 | 104.80 | 141.62 | |||
| SO50273_1 | 8358-4E59-86 | PO16211117741 | 100 | 285 | 308 | 99 | 5 | 2023-02-14 | 744.27 | 18.61 | 2023-02-02 | 1 | 660.91 | 1 | 744.27 | 1 | SO50273 | 2023-02-09 | 59.54 | 660.91 | 744.27 | |||
| SO51799_1 | 9372-4D4A-AF | PO16211136640 | 100 | 285 | 525 | 99 | 5 | 2023-05-17 | 158.43 | 3.96 | 2023-05-05 | 1 | 144.59 | 1 | 158.43 | 1 | SO51799 | 2023-05-12 | 12.67 | 144.59 | 158.43 | |||
| SO51799_2 | 9372-4D4A-AF | PO16211136640 | 100 | 285 | 599 | 99 | 5 | 2023-05-17 | 323.99 | 8.10 | 2023-05-05 | 1 | 294.58 | 1 | 323.99 | 2 | SO51799 | 2023-05-12 | 25.92 | 294.58 | 323.99 | |||
| SO51799_3 | 9372-4D4A-AF | PO16211136640 | 100 | 285 | 549 | 99 | 5 | 2023-05-17 | 218.45 | 5.46 | 2023-05-05 | 1 | 199.38 | 1 | 218.45 | 3 | SO51799 | 2023-05-12 | 17.48 | 199.38 | 218.45 | |||
| SO57108_1 | FF80-4FA7-94 | PO16211160206 | 100 | 285 | 595 | 99 | 5 | 2023-08-17 | 338.99 | 8.47 | 2023-08-05 | 1 | 308.22 | 1 | 338.99 | 1 | SO57108 | 2023-08-12 | 27.12 | 308.22 | 338.99 | |||
| SO63189_1 | BB3B-4D4C-A6 | PO16211129800 | 100 | 285 | 516 | 99 | 5 | 2023-11-17 | 23.48 | 0.59 | 2023-11-05 | 1 | 17.38 | 1 | 23.48 | 1 | SO63189 | 2023-11-12 | 1.88 | 17.38 | 23.48 | |||
| SO63189_2 | BB3B-4D4C-A6 | PO16211129800 | 100 | 285 | 475 | 99 | 5 | 2023-11-17 | 41.99 | 1.05 | 2023-11-05 | 1 | 26.18 | 1 | 41.99 | 2 | SO63189 | 2023-11-12 | 3.36 | 26.18 | 41.99 | |||
| SO63189_3 | BB3B-4D4C-A6 | PO16211129800 | 100 | 285 | 295 | 99 | 5 | 2023-11-17 | 1637.40 | 40.94 | 2023-11-05 | 2 | 747.20 | 1 | 1637.40 | 3 | SO63189 | 2023-11-12 | 130.99 | 1494.40 | 818.70 | |||
| SO69485_1 | E19F-443F-BB | PO16211116121 | 100 | 285 | 599 | 99 | 5 | 2024-02-15 | 323.99 | 8.10 | 2024-02-03 | 1 | 294.58 | 1 | 323.99 | 1 | SO69485 | 2024-02-10 | 25.92 | 294.58 | 323.99 | |||
| SO69485_2 | E19F-443F-BB | PO16211116121 | 100 | 285 | 474 | 99 | 5 | 2024-02-15 | 125.98 | 3.15 | 2024-02-03 | 3 | 26.18 | 1 | 125.98 | 2 | SO69485 | 2024-02-10 | 10.08 | 78.53 | 41.99 | |||
| SO69485_3 | E19F-443F-BB | PO16211116121 | 100 | 285 | 359 | 99 | 5 | 2024-02-15 | 2753.99 | 68.85 | 2024-02-03 | 2 | 1251.98 | 1 | 2753.99 | 3 | SO69485 | 2024-02-10 | 220.32 | 2503.96 | 1376.99 | |||
| SO69485_4 | E19F-443F-BB | PO16211116121 | 100 | 285 | 543 | 99 | 5 | 2024-02-15 | 37.25 | 0.93 | 2024-02-03 | 1 | 27.57 | 1 | 37.25 | 4 | SO69485 | 2024-02-10 | 2.98 | 27.57 | 37.25 | |||
| SO69485_5 | E19F-443F-BB | PO16211116121 | 100 | 285 | 593 | 16 | 99 | 5 | 45.20 | 2024-02-15 | 113.00 | 1.70 | 2024-02-03 | 1 | 308.22 | 1 | 67.80 | 5 | SO69485 | 2024-02-10 | 5.42 | 308.22 | 113.00 | 0.40 |
Generated 2024-05-04 16:19:53.396 UTC